List:General Discussion« Previous MessageNext Message »
From:Ace Dimitrievski Date:August 15 2005 9:38pm
Subject:Re: French Characters, Still no answer
View as plain text  
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
--- jsherwood@stripped
<jsherwood@stripped> 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" <bruce@stripped>
> To: "James Sherwood" <jsherwood@stripped>
> Cc: <mysql@stripped>
> 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/mysql?unsub=1
> >
> >
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
http://lists.mysql.com/mysql?unsub=1
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
Thread
French Characters, Still no answerJames Sherwood15 Aug
  • Re: French Characters, Still no answerBruce Dembecki15 Aug
  • Re: French Characters, Still no answerJames Sherwood15 Aug
  • Re: French Characters, Still no answerGleb Paharenko15 Aug
  • Re: French Characters, Still no answerJames Sherwood16 Aug
    • Re: French Characters, Still no answerGleb Paharenko16 Aug
  • Re: French Characters, Still no answerJames Sherwood16 Aug
    • Re: French Characters, Still no answerJason Pyeron16 Aug
  • Re: French Characters, Still no answerJames Sherwood16 Aug
Re: French Characters, Still no answerAce Dimitrievski15 Aug
  • Re: French Characters, Still no answerJames Sherwood16 Aug