Board index » delphi » Character set for eurosign/change the default character set

Character set for eurosign/change the default character set

Hello !

I know it's a little bit late, and there was many answers about it, but:

Which Character Set is the best one to use in German to make it possible
to save the eurosign (?) in a table ?

Our Database is using ISO_8859. When i create a Database with Default
Character Set None,
i can Save the eurosign.
My second Question is how do i Change easily the Character Set of a Database
?
(Must i copy each Table do a new Database ?)

Thanks for helping !
Thilo

 

Re:Character set for eurosign/change the default character set


Thank you for Helping !
i would try it, an Greetings to H. Jaklin !

"Thomas Steinmaurer" <t...@iblogmanager.com> schrieb im Newsbeitrag
news:3d5ba1bc$1@dnews...

Quote
> Hello Thilo,

> "Thilo Schmitz" <tschm...@ohra.de> schrieb im Newsbeitrag
> news:3d5b9b3c@dnews...
> > Hello !

> > I know it's a little bit late, and there was many answers about it, but:

> > Which Character Set is the best one to use in German to make it possible
> > to save the eurosign (?) in a table ?

> Depends if you are using the BDE or not. ISO8859_1 should be fine for
> Non-BDE applications. With the BDE you should use WIN1252 as
> InterBase character set and the 'WEurope' Ansi BDE Language driver.

> > Our Database is using ISO_8859. When i create a Database with Default
> > Character Set None,
> > i can Save the eurosign.

> Don't use NONE as character set. See above for the proper one. And as
> collation on field level, you should use DE_DE.

> > My second Question is how do i Change easily the Character Set of a
> Database
> > ?
> > (Must i copy each Table do a new Database ?)

> Yes, this would be the safest way. Another one would be to hack system
> tables
> directly, which is not recommended, but probably possible. As I know your
> OHRA company, you could contact me privately ;-).

> Regards,
> Thomas Steinmaurer
> IB LogManager 2.0 - The Logging/Auditing Tool for InterBase and FireBird
> http://www.iblogmanager.com

Other Threads