Hi Peter,

Thanks for the info. We'll try to avoid order by etc... the only other
option is to ship our product with multiple databases, or the ability to
generate a database with a different character set, which we're not really
keen on doing.

Regards,

Peter Lee

At 7/03/2004, you wrote:

>Hi Peter Lee,
>
>--- In firebird-support@yahoogroups.com, Peter Lee <ptle@r...> wrote:
>[...]
> > file that can support English, German Chinese? Before we started
>with FB,
> > we used Paradox tables, and had our 'multilanguage' tables as 'ascii
>(ANSI)'.
> >
> > Our English, Chinese and Hungarian all worked fine with this, and all
> > characters displayed correctly, as long as the user has the correct
>windows
> > language version (and character sets loaded). Is this type of behavior
> > possible with firebird?
>[...]
>
>It depends what language support you expect from the database. Most
>difficult area is sorting.
>
>What you've done witrh your Paradox Database, was essentionall CHARSET
>NONE in terms of Firebase.
>
>You gave your DBMS some strings of 8bit (possibly MB) characters and
>told the DBMS not to care what these strings are. Interpretation was
>then using the system settings of the computer/OS.
>
>This works fine, ehn
>- all computers connected agree on system locale
>- the DBMS isn't require to do culture correct sorting
>
>Regards,
>Peter Jacobi
>
>
>
>
>
>
>
>
>
>
>
>
>
> >
> > We have cut and pasted some of our strings into our database, using
> > IBExpert, and they seem to come in and out ok... things such as
> > Elõjegyzések (Hungarian) and µ÷ºÅ (Chinese).
> >
> > Thanks,
> >
> > Peter Lee
> >
> >
> > -
> > Peter Lee Mobile: +61 412 011 174 ptle@r...
> > -----------------------------------------------------------------------
> > Rising Software Australia Pty. Ltd. http://www.risingsoftware.com/
> > Publishers of 'Auralia' - Ear Training and 'Musition' - Theory Training
> > Ph: +61 3 9481 3320 FAX: +61 3 9481 3380 USA Freecall: 1 888 667 7839
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>

-
Peter Lee Mobile: +61 412 011 174 ptle@...
-----------------------------------------------------------------------
Rising Software Australia Pty. Ltd. http://www.risingsoftware.com/
Publishers of 'Auralia' - Ear Training and 'Musition' - Theory Training
Ph: +61 3 9481 3320 FAX: +61 3 9481 3380 USA Freecall: 1 888 667 7839