Hello, I dont think we want to go this route as it was working fine on the 4.0 database on the other server.
I also might add that the old server was linux, and the new one is Windows 2000 Server Thanks, James ----- Original Message ----- From: "Ace Dimitrievski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <mysql@lists.mysql.com> Sent: Monday, August 15, 2005 6:38 PM Subject: Re: French Characters, Still no answer > Im not sure if my experience will be of any help but > here it is: > I used a database with utf8 as default charset (you > can easily set this with mysql administrator) and the > columns that I needed to store Macedonian cyrilic > characters were varchar. Some letters were stored as > ?. When I changed the column type to varbinary I was > able to store/retreive all the letters properly. > However if you change the type of the columns you > cannot use the mysql adminisators backup sql queries > to restore a database that contains utf8 characters > (at least I failed). Using a PHP script will help. For > those that use mySQL with some script language using > base64 encoding/decoding funtions for non latin1 > letters is the safest way (however you cannot strictly > predict the lenght of the encoded string based on the > lenght of the plaintext). > best regards > --- > Ace Dimitrievski, > research assistant, > Faculty of Electrical Engineering Skopje > --- [EMAIL PROTECTED] > <[EMAIL PROTECTED]> wrote: > > The older version is 4.xx.xx im not sure how to > tell. > > > > New version is 4.1.12 > > > > Thank you, > > James > > > > > > ----- Original Message ----- > > From: "Bruce Dembecki" <[EMAIL PROTECTED]> > > To: "James Sherwood" <[EMAIL PROTECTED]> > > Cc: <mysql@lists.mysql.com> > > Sent: Monday, August 15, 2005 2:50 PM > > Subject: Re: French Characters, Still no answer > > > > > > > Still no answer, perhaps, but ther'es still no > question. > > > > > > Per my earlier response... What version of MySQL > is the old version > > > you refer to, what version is the new version you > refer to? With that > > > information someone here is more likely to be able > to tell you > > > something useful... without that you're not likely > to get much of a > > > response. > > > > > > Best Regards, Bruce > > > > > > On Aug 15, 2005, at 7:59 AM, James Sherwood wrote: > > > > > > > I am still having trouble with french characters > if anyone has ANY > > > > ideas, please help. > > > > > > > > We have installed the newest version of MySql > and cannot get it to > > > > play nice > > > > with French characters. Our older version > worked fine. The > > > > problem may (or > > > > may not) be that when we put the dump into the > new database(yes its > > > > default > > > > charset is Utf8) the default character set for > the table is Utf8 > > > > but some > > > > fields are like this: > > > > > > > > 'Story' longtext character set latin1 NOT NULL > > > > > > > > We tried linking our tomcat to the old database > on the other server > > > > through > > > > this tomcat and everything works fine but when > we link the tomcat > > > > back to > > > > the new database, it will not play nice with > french characters. > > > > (they come > > > > out as outlined squares etc) > > > > > > > > Any ideas would be greatly appreciated > > > > James > > > > > > > > > > > > > -- > > > 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] > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.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]
