wrong charset enconding with external MSSQL database

Moderator: crythias

rubenzsolt
OTRS newbie
Posts: 6
Joined: 02 Jan 2017, 11:26
OTRS Version?: OTRS5

wrong charset enconding with external MSSQL database

Postby rubenzsolt » 27 Nov 2017, 23:09

I have connected an external MSSQL database for customer users, the connection is working, but the OTRS not show the corect caracters.
The MSSQL database use Hungarian_CI collation but on OTRS now show corectly the special caracters(ÜÓŐÚŰÁÉÍ).
When I connect over isql -v SERVER sa Password123 I see in database corect the special caracters, si I think somewhere OTRS is convert incorectly.
Thanks for helping

jojo
Moderator
Posts: 14038
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: wrong charset enconding with external MSSQL database

Postby jojo » 27 Nov 2017, 23:22

Did you a conversion in the configuration? OTRS otherwise awaits utf-8 only
"Production": OTRS Business Solution™ 6, STORM powered by OTRS
"Testing": OTRS git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

rubenzsolt
OTRS newbie
Posts: 6
Joined: 02 Jan 2017, 11:26
OTRS Version?: OTRS5

Re: wrong charset enconding with external MSSQL database

Postby rubenzsolt » 27 Nov 2017, 23:34

Hi, I attach my config

$Self->{CustomerCompany} = {
Name => 'CustomerCompanyMSSQL',
Module => 'Kernel::System::CustomerCompany::DB',
Params => {
DSN => 'DBI:ODBC:OTRS',
Type => 'mssql',
User => 'sa',
Password => 'Password123',
Table => 'customer_company',
ForeignDB => 1,
#CaseSensitive => 0,
},

CustomerCompanyKey => 'customer_id',
CustomerCompanyValid => 'valid_id',
CustomerCompanyListFields => ['customer_id', 'name' ],
CustomerCompanySearchFields => ['customer_id', 'name'],
CustomerCompanySearchPrefix => '*',
CustomerCompanySearchSuffix => '*',
CustomerCompanySearchListLimit => 250,

jojo
Moderator
Posts: 14038
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: wrong charset enconding with external MSSQL database

Postby jojo » 27 Nov 2017, 23:49

You should configure your ODBC driver to convert the data to utf8
"Production": OTRS Business Solution™ 6, STORM powered by OTRS
"Testing": OTRS git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

rubenzsolt
OTRS newbie
Posts: 6
Joined: 02 Jan 2017, 11:26
OTRS Version?: OTRS5

Re: wrong charset enconding with external MSSQL database

Postby rubenzsolt » 27 Nov 2017, 23:56

Hi, this is my odbc.ini config

[OTRS]
Driver=FreeTDS
TDS_Version=7.4
Server=192.168.10.1
Port=1433
Database=otrs


Return to “General”

Who is online

Users browsing this forum: No registered users and 5 guests