I am trying to store Greek characters in a custom attribute of a document and the characters replaced by question marks. The mysql database is in utf8 encoding and as I saw it has the question marks in the table's field value but I can replace them to Greek in database.
Is there any setting I can use to fix this issue?
Question marks on non English characters
Moderator: car031
Post
Re: Question marks on non English characters
Hi maznick,
what is exactly the version of LogicalDOC you're using?
Does the problem occur both on the filename and the attributes or only on the attributes?
If it only occurs on the attributes you should try to check the properties of table ld_document_ext and the ld_stringvalue column
what is exactly the version of LogicalDOC you're using?
Does the problem occur both on the filename and the attributes or only on the attributes?
If it only occurs on the attributes you should try to check the properties of table ld_document_ext and the ld_stringvalue column
Post
Re: Question marks on non English characters
Here is a useful link:
https://stackoverflow.com/questions/104 ... -column-is
Here are some queries
For Table 'ld_document_ext':
For Column 'ld_stringvalue' :
https://stackoverflow.com/questions/104 ... -column-is
Here are some queries
For Table 'ld_document_ext':
Code: Select all
SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,
information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
WHERE CCSA.collation_name = T.table_collation
AND T.table_schema = "your-schema-name"
AND T.table_name = "ld_document_ext";
Code: Select all
SELECT character_set_name FROM information_schema.`COLUMNS`
WHERE table_schema = "your-schema-name"
AND table_name = "ld_document_ext"
AND column_name = "ld_stringvalue";
Post
Re: Question marks on non English characters
Hi agaspa,
I am using the latest veraion 8.1.1 and all the fields in mysql database are in utf8-bin collation and when I update the fields from database values are stored in Greek. So I don't think the problem is from database. Do you have any idea about that?
I am using the latest veraion 8.1.1 and all the fields in mysql database are in utf8-bin collation and when I update the fields from database values are stored in Greek. So I don't think the problem is from database. Do you have any idea about that?
Post
Re: Question marks on non English characters
Hi Agaspa,
I tried the queries you sent me and the response is utf8.
I also tried to use Greek characters in other fields and in all I receive the same result all the characters are changed to "?".
I have also attached and a screenshot of the problem.
Can you please help me.
I tried the queries you sent me and the response is utf8.
I also tried to use Greek characters in other fields and in all I receive the same result all the characters are changed to "?".
I have also attached and a screenshot of the problem.
Can you please help me.
- Attachments
-
- logicaldoc_sshot.png (27.42 KiB) Viewed 2644 times
Who is online
Users browsing this forum: No registered users and 15 guests