I have reinstalled the v3 RPM again to my system, and used one of my original backups from that same version. In 3.23 there is no 'collation' field.. I wonder if that is the problem?? I am going to change it to latein1_bin to see what happens next..
Thanks! I'll let you know! In a message dated 1/7/2005 3:44:25 AM Eastern Standard Time, Tom Molesworth <[EMAIL PROTECTED]> writes: >Hi there, > >[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> wrote on Thursday, January >06, 2005 7:19 PM: >> Thanks for the reply! I show the following information for my DB, >> and shows the same for both the 3.23 DB And the 4.18a DB >> >> Field ---- Type ---- Collation >> avatardata ---- mediumtext ---- latin1_swedish_ci > >It'd be better to use a BLOB, I think, because this would avoid the >translation issues. Other alternatives worth pursuing: > >* Add the "BINARY" flag to the field - "avatardata MEDIUMTEXT BINARY", for >example. >* Use a different collation, preferably one that's not case insensitive (the >'ci' part of the collation) >* Use "latin1_bin" on the new DB (and you might need to use >_latin1_bin"data" instead of just "data" when doing inserts) >http://dev.mysql.com/doc/mysql/en/Charset-literal.html >* Force the collation type, using the COLLATION keyword, as in >http://dev.mysql.com/doc/mysql/en/Charset-collate.html > >> I pasted a data table from the bad avatar and the good avatar >> to a file differential program, there was no differential at all >> that the system found.. > >If you want to send me (directly, rather than via the list) one of the >records, as taken from both the bad and good versions, I could take a look >for you. The binary files differ, so I'm not too sure what data is being >used when you did the paste-and-compare. > >> I'm not too sure where or what to do to change this >> information? Do you mean >> that I recompile MySQL using different ./configure commands? > >Shouldn't need to recompile, as long as you have the right charactersets >available (which should be the default, I think). > >cheers, > >Tom > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]