w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
MySQL database not saving non-latin characters in VARCHAR field correctly

SqlServer varchar only supports single-byte-character-sets such as Latin-1.

If you have control of the database, try using nvarchar which supports double-byte character-sets.

varchar overview: http://dev.mysql.com/doc/refman/5.5/en/char.html

Latin-1 Supported characters: http://en.wikipedia.org/wiki/ISO/IEC_8859-1

© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.