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?
Diacritics not displaying correctly
Moderators: Jon, Steve, Ian, Dave
-
- Ebase User
- Posts: 1
- Joined: Tue Aug 29, 2017 5:43 am
- Wai
- Moderator
- Posts: 165
- Joined: Wed Sep 12, 2007 9:04 am
- Location: Sandy, UK
- Contact:
Re: Diacritics not displaying correctly
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:
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:
1 x
Who is online
Users browsing this forum: No registered users and 14 guests