Hi,
I would love to be forwarded any messages that people send you
about this issue, as I'm in a very similar situation to you.
On Mac OSX, we have a database into which we "feed" texts files
of sql with the Spanish characters intact, but then in the
database the accent marks and such don't show up properly, just
as you described.
I believe the problem has to do with MAC vs. UNIX special
character encodings.
At the moment here is our workaround in our PHP/MySQL web
application:
-- "feed" the text files into MySQL (resulting in "bad" accents
in database)
-- whenever a web app is going to send the results of a query to
a browser, a "convert_accents" PHP function I've written
converts the database-internal character codes into their
html equivalents
-- the user sees the Spanish the way it should be
This works, but surely there is a better solution!
Reid
[EMAIL PROTECTED]
----------
>From: Juergen Schreck <[EMAIL PROTECTED]>
>To: MYSQL List <[EMAIL PROTECTED]>
>Subject: Charset Question - Spanish?
>Date: Mon, Feb 11, 2002, 1:33 PM
>
> Hi,
>
> I've read the man pages on this, but I can't figure out what to do. I
> have =
> a
> tab-delimited textfile containing spanish characters. I import those
> record=
> s
> using LOAD DATA INFILE... . All the special spanish chars are converted
> to
> something different. How can I correct this? The columns in question
are
> al=
> l
> created as VARCHAR and BINARY is not set for those columns.
>
> My default charset is Latin1. Other charsets installed are:
>
latin1=A0dec8=A0dos=A0german1=A0hp8=A0koi8_ru=A0latin2=A0swe7=A0u
sa7=A0cp1
> 251=A0danish=A0hebrew=A0
>
win1251=A0estonia=A0hungarian=A0koi8_ukr=A0win1251ukr=A0greek=A0w
in1250=A0
> croat=A0cp1257=A0
> latin5
>
> Mysql verison 3.32.47 OSX.
>
> Do I need another charset?
>
> Please help,
> Juergen Schreck
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
