Problems with Mexican accents (was "...German umlaute")
Problems with Mexican accents (was "...German umlaute")
- Subject: Problems with Mexican accents (was "...German umlaute")
- From: Ricardo Strausz <email@hidden>
- Date: Wed, 30 Jul 2003 13:59:02 -0500
On martes, juli 29, 2003, at 19:32 America/Mexico_City, Pierre Frisch
wrote:
I don't have direct experience with Sybase but I know some who has; I
will talk to him. What are your problems?
Accented characters (which are quite common in spanish) are changed by
"funny" ones. The data is/was captured (and is in use) in a small
network of HP-Apollos running NeXTSTEP 3.3 (with EOF 1.0). In the NeXT
side, every thing looks fine. However, since I am trying to port my
apps to OSX, I had not been able to "see" correctly the strings-data.
Neither inside an app nor in a terminal... in fact, this last is quite
rare: I do a telnet from my Mac to my server (a NeXT box) and inside
that session I run the isql utility, but the strings look wrong.
As for UTF-8 I went through hell with Oracle until I convinced the DB
Admin to change the default encoding to UTF-8 and all the problems
disappeared. Check what encoding your DB is using and then check the
transposition that the jdbc driver is using. You don't want any
conversion the Strings are UTF-8 native in Java they must be stored as
is in the DB any string conversion is a source of problem.
In my case I am the db-admin, so I will not have to convince no one but
my self ;^}
Sybase 11.5 for NT supports ascii_8, cp850, cp437, iso-1, mac and
roman8 charsets... currently it is in cp850 and that is what I tried in
my connection, with out results... I will try tonight with a "test-db"
the others to see what happens; I'll let you know.
Thanks
Dino
The problem with US DB system is that the UTF-8 encoding switch is an
obscure feature in the documentation. It certainly is with Oracle.
Pierre
On Tuesday, July 29, 2003, at 11:19 AM, Ricardo Strausz wrote:
Hola Pierre
Do you have some experience in Sybase 11.5 (for WinNT)??
any advise will be wellcome (PLEASE)
Dino
On lunes, juli 28, 2003, at 19:29 America/Mexico_City, Pierre Frisch
wrote:
The internationals characters problems are not unique to any one
database. Some are more prone than others, in particular the "older"
do not store String as UTF-8 by default but most will accept to use
UTF-8 as the default String encoding. This is the key to success try
to make you application UTF-8 clean, this is a bit of work at the
beginning but then you will leave those issue behind you for ever.
When I talk about UTF-8 clean I mean DB encoding in UTF-8, Component
encoded in UTF-8 and WOResponse, WORequest as well as URL encoded in
UTF-8. It you are careful to set it up properly then everything
works like a charm. You can enter any character you want, you can
even let your user type their chinese name the right way without any
trouble.
There are some indication on how to achieve this on
http://www.wodev.com. Nothing on mySQL yet but please contribute
this will help the entire community.
Pierre
On Monday, July 28, 2003, at 11:01 AM, Ricardo Strausz wrote:
On lunes, juli 28, 2003, at 11:53 America/Mexico_City, Mieke
Banderas wrote:
Christian, email@hidden said it like this:
Perhaps we should start collecting information and set up a
little "Guide to MySQL and German umlaute"?
Is this umlaut problem to the best of the lists members knowledge
unique
to mySQL? What about Frontbase, Openbase and PostgreSQL for
instance?
I have simmilar problem using Sybase 11.5 with acented characters...
_______________________________________________
WebObjects-dev mailing list
email@hidden
http://www.omnigroup.com/mailman/listinfo/webobjects-dev
_______________________________________________
WebObjects-dev mailing list
email@hidden
http://www.omnigroup.com/mailman/listinfo/webobjects-dev
_______________________________________________
WebObjects-dev mailing list
email@hidden
http://www.omnigroup.com/mailman/listinfo/webobjects-dev
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.