help with message: "Warning: mssql_query(): WARNING! Some character(s) could not be converted into client's character set." in php coversion script. [SOLVED]
MySQL
1
Posts
1
Posters
8
Views
1
Watching
-
Hi i am writing a small conversion script to move data from a mssql table to a mysql table. Both tables have the same names and same colum names. Data types are close in purpose. But when I run the script I get the warning above and I would like to fix this to get the full data. As I understand it the message is comming from the ms sql server on a windows machine and the target mysql is on a linux machine. Ideas? Nevermind, I figured it out with a bit more hunting. MSSQL adds an odd character encoding to the NVARCHAR (and other N-prefixed data types). My fix was to cast it to a varchar... select CAST(field as VARCHAR) as field from table
Chris J www.redash.org