tag:blogger.com,1999:blog-4638805504123061057.post6567265403489845323..comments2023-04-26T17:07:12.881+03:00Comments on Vectoring Ruby On Rails: Encoding problemsAlexeyhttp://www.blogger.com/profile/01888820688161272210noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-4638805504123061057.post-2910330413716224962009-02-22T04:25:00.000+02:002009-02-22T04:25:00.000+02:00i had a similar problem with storing utf strings ...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.Unknownhttps://www.blogger.com/profile/09145346647422467521noreply@blogger.comtag:blogger.com,1999:blog-4638805504123061057.post-74845850400099241002008-05-29T13:26:00.000+03:002008-05-29T13:26:00.000+03:00I had "???" when i converted (from latin1 to UTF8)...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.<BR/><BR/>In case of UTF16/32 you need to do everything from beginning and replace UTF8 to UTF16 (or UTF32) respectively.Alexeyhttps://www.blogger.com/profile/01888820688161272210noreply@blogger.comtag:blogger.com,1999:blog-4638805504123061057.post-20228974300887617452008-05-28T17:34:00.000+03:002008-05-28T17:34:00.000+03:00Never mind. I was expanding what you wrote with a...Never mind. I was expanding what you wrote with a SET NAMES command and that seems to be what created the truncation issue.<BR/><BR/>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?TPolhttps://www.blogger.com/profile/05660049272022485471noreply@blogger.comtag:blogger.com,1999:blog-4638805504123061057.post-12469674319403428282008-05-28T11:42:00.000+03:002008-05-28T11:42:00.000+03:00What exactly you mean ?Exception ?What exactly you mean ?<BR/>Exception ?Alexeyhttps://www.blogger.com/profile/01888820688161272210noreply@blogger.comtag:blogger.com,1999:blog-4638805504123061057.post-28171077507107631662008-05-28T00:00:00.000+03:002008-05-28T00:00:00.000+03:00I attempted your approach and found that data in f...I attempted your approach and found that data in fields defined as Text were truncated. Do you have any suggestions?TPolhttps://www.blogger.com/profile/05660049272022485471noreply@blogger.com