Quick question if anyone can help. I was reading through the manual and it states something about the character sets being different from mysql version 4 to version 4.1.1
We have just upgraded from 4 to version 4.1.1 and are having problems with accent characters on our database table. Some fields import with the correct characters yet the one field called description of type TEXT does not insert with the characters instead it puts a ? in its place. Could the effect of this from the manual: ----------------- Finally, there is a different file format for storing information about character sets and collations. Make sure that you have reinstalled the Œ/share/mysql/charsets/¹ directory containing the new configuration files. ------------------ Cause this to happen? Please help. Thanks Barry ---------------------------------- Barry Zimmerman Administrator Fishingvenues.com http://www.fishingvenues.com ---------------------------------- > From: Victor Pendleton <[EMAIL PROTECTED]> > Date: Mon, 2 Aug 2004 13:46:02 -0500 > To: "'Barry Zimmerman '" <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" > <[EMAIL PROTECTED]> > Subject: RE: Mysql and PHPMYadmin > > Do you know the ASCII values for the characters that are being turned into > question marks? Are you able to verify that the data is not be imported by > querying the underlying ascii value? > > -----Original Message----- > From: Barry Zimmerman > To: [EMAIL PROTECTED] > Sent: 8/2/04 1:00 PM > Subject: Mysql and PHPMYadmin > > Hi, > > Hoping that someone can help me, as I have tried everywhere for help and > still cannot get this to work. > > I am using MySQL 4.1.1 > > I have a sql file that contains french accent characters. I have 8 > fields in > my database. Now the content of the text file imports into my database, > when > I import the text into the database some fields enter the accent > characters > correctly and others do not. > > The field type varchar imports the text no problem. > > The field type text does not, it converts my accents into ? and does not > import them. > > I have tried to change the character sets and this also does not work. > Does > anyone know how I can solve this problem. Also what is the correct > character > set and collation for french characters. > > Please could someone help. > > Thanks > > Barry > ---------------------------------- > Barry Zimmerman > Administrator > > Fishingvenues.com > http://www.fishingvenues.com > ---------------------------------- > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
