Hi.
I have big ifx databases based on en_US.819 collation. Database
contains polish signs, which im unable to present on my web
application (ASP.NET) properly (getting #@$@#%^ instead of proper
signs). Does anyone know how to convert en_US.819 to pl_pl.8859-2 or
other polish collation ? Tried to set db_locale and client_locale in
connection_string but it seems it does nothing.


READ BELOW !!
Before answer, read this - https://www.ibm.com/developerworks/f...35994&tstart=0.
This is my question and conversation at the other forum.

Can we know the following:

- What is your Informix version?
- What are the settings on your client (DB_LOCALE and CLIENT_LOCALE)
- What WERE the settings on your client when you inserted the polish signs?
- If your database has en_US.819 how did you insert the characters?

I believe you're more or less "trapped" in a nasty situation due to old
problems with the product (that allowed bad use).
Probably the answer you got on DeveloperWorks forum is correct, but the
above will help to clarify this.

Regards.

2010/8/4 Michał Karasiński <mkarasinski86 (AT) gmail (DOT) com>



--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

One suggestion, create a staging database with the Polish pl_pl.8859-2
locale. Then your web app can copy data from the live database that it
needs to access into a temp table in the 'Polish' database and fetch it from
there. A bit klunky, but it may serve for a while until you can convert the
entire database to the Polish locale by exporting and re-importing it into a
database with the correct locale.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



2010/8/4 Michał Karasiński <mkarasinski86 (AT) gmail (DOT) com>

Thanks very much for the response. We have been prepaired that
reexport will occur sooner or later. Noone wanted it, but we just knew
it. Tomorrow ill try that things u say. Tx once more.