I am developing multilingual web sites with all the info extracted from databases.
In using MySQLCC/SQLyog to stack up some static base data into MyISAM tables the field type is text I discovered that some of the data was truncated immediately prior to a 'n [single quote n] the balance of the data is lost. removing the quote solves the problem. The data is multilingual text requiring a number of non standard codings. The problem also appears with the character e with ^ above. [alt 0234] ê and also ë [alt 0235].
I have the coding set to Unicode and as far as I can see have set up the system correctly.
If important I am version running 4.1 on Win XP SP2 IIS.
I have managed a temporary workaround but it required a significant amount of additional work.
Many thanks in advance
Rob
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]