Diacritics not displaying correctly

Post any questions you have about using the Verj.io Studio, including client and server-side programming with Javascript or FPL, and integration with databases, web services etc.

Moderators: Jon, Steve, Ian, Dave

reneeverts
Ebase User
Posts: 1
Joined: Tue Aug 29, 2017 5:43 am

Diacritics not displaying correctly

#1

Postby reneeverts » Wed Aug 30, 2017 7:05 am

I have a problem with diacritics which aren’t displayed as it should in the SQL database.

When I insert a query with a diacritic in the database itself it’s not a problem and the diacritic is shown as it should. Also I debugged the insert query from Ebase and it shows the diacritic as it is:
INSERT INTO MI _IMPORT (
BIC_ZNAME
,EE_SNAME
)
VALUES (
'Açam'
,'AÇAM'
)

When I look in the database it displays the name as: 'Açam' but I expect/want 'Açam' to be displayed.

The datatypes are NVARCHAR and the column collations are Latin1_General_CI_AS. In Ebase the fields are VARCHAR.

Is there something I can do to insert the diacritics correctly in the database from Ebase?
0 x

User avatar
Wai
Moderator
Moderator
Posts: 165
Joined: Wed Sep 12, 2007 9:04 am
Location: Sandy, UK
Contact:

Re: Diacritics not displaying correctly

#2

Postby Wai » Tue Oct 10, 2017 9:22 am

Did you ever find a solution to this?

It's not really an Ebase issue, it's down to the collation in the database.

This link is quite useful:
https://blogs.msdn.microsoft.com/sqlmed ... your-data/

Here is a screenshot of it working in SQL Server after data is inserted from Ebase:
Image
1 x


Who is online

Users browsing this forum: Google [Bot] and 6 guests