Comments on Vectoring Ruby On Rails: Encoding problems

i had a similar problem with storing utf strings ...

2009-02-22T04:25:16.439+02:00

i had a similar problem with storing utf strings that were encrypted into a mysql database from ror, they kept being truncated. setting the mysql field datatype to text/binary allowed me to store and retrieve these complex strings automatically.

I had "???" when i converted (from latin1 to UTF8)...

2008-05-29T13:26:57.486+03:00

I had "???" when i converted (from latin1 to UTF8) of japanese and other languages that should be encoded to UTF16/32 becausethey didnt have "symbols" in UTF8 table.

In case of UTF16/32 you need to do everything from beginning and replace UTF8 to UTF16 (or UTF32) respectively.

Never mind. I was expanding what you wrote with a...

2008-05-28T17:34:44.713+03:00

Never mind. I was expanding what you wrote with a SET NAMES command and that seems to be what created the truncation issue.

Have you come across the ???? question marks caused by inserting data using a UTF8 client connection to a latin1 table. I haven't found a way to fix data stored in this fashion, do you know if it can be fixed?

What exactly you mean ?Exception ?

2008-05-28T11:42:04.018+03:00

What exactly you mean ?
Exception ?

I attempted your approach and found that data in f...

2008-05-28T00:00:15.457+03:00

I attempted your approach and found that data in fields defined as Text were truncated. Do you have any suggestions?