On Sep 10, 9:00 pm, SushiSean <SushiS...@discussions.microsoft.com>
wrote:
Try to add prefix N in your sql statement
INSERT ... VALUES (N'....', ......
Wow. Cool, it works. Thanks a lot. But can you told me why?
ON my local pc it works without any N, but when I put this on hosting I need
modify queries to have this N. Why? It is some settings of database?
It means that server on remote host has different code page and when a
database got a unicode string and save it, any characters in the
unicode string that do not exist in the code page will be lost. When
you use prefix N you tell to database that you send unicode.
"N" stands for National Language in the SQL-92 standard and must be
uppercase