Subject Re: [firebird-support] cannot transliterate characters
Author Sergio H. Gonzalez
"Milan Babuskov" <milanb@...> escribió
> What is the Database charset and what is the connection charset?

Hello Milan, thanks for the reply!

Just now I realize (I made a metadata extraction to see it) that my DB has
WIN1251

DEFAULT CHARACTER SET WIN1251;

I also see this line and I don't know what it means...

SET NAMES WIN1251;

How can I change the character set to iso8859_1 ? I want to use it because is
has a accent-insensitive collation. Sorry if this is a silly question!

> and which client application are you using?


I'm using Delphi 6 with IBX:

object qActualizarStock: TIBQuery
Database = DM.IBdb
Transaction = DM.IBtr
SQL.Strings = (
'SELECT'
' OUT_ARTICULO_NUEVO'
'FROM'
' ACTUALIZAR_ARTICULOS('
' :CODIGO_SEGUN_PROVEEDOR,'
' :DESCRIPCION,'
' :ID_SUBGRUPO,'
' :ALICUOTA_IVA,'
' :COSTO,'
' :ID_MONEDAS)'
''
' ')