When I conect SQL server to outsystems,but when i create data to table in SQL server ,it's only show ????,I try to with data type is nvachar and set value to insert to "N'" + japan characters ,it is not work
Hi Toan,
In Service Center > Administration > Database Connections > Check to "Enable Unicode Support"
Click to Save and Apply Setting to the Factory, refresh your entity in extension and enjoy it.
it's work ,thank you
Hello Chung
I've done this and also the data type is Nvarchar2 only..But still the japan characters in the DB are replaced with question marks and other special characters.
Kindly help me in solving this.
Regards,
Vijay
Hi Vijay,
For attribute with text data type and Japanese characters, when you insert new data into the table, add N before its value as in the example below.
INSERT INTO [dbo].[Status] ([Label],[Is_Active])
VALUES
(N'未対応','True'),
(N'承認済','True')
Hope it's useful to you.
Chung
Hello chungThank you for your response.
I've did this but still I'm not getting the expected result.
Am I missing something on DB language settings?
Any clues from the beginning of integration process would be helpful.
Did you get the solution , Even i am facing same issue with Arabic texti have enabled the unicode and apply factory setting and try to save arabic in "N'"+"مرحبا بالعالم" but still the result is N'??????
Thanks, your solutions worked wonderfully, once the setting is in place you don't even need to use N prefix since all strings are UTF-8 by default. Prefixing N makes the characters UTF-16
HiIn the DB settings, you can change the collation to the appropriate language format.Hope it's useful to you.
Hello,
Please refer this first post link which is related to your question and 2 more to get help to your query.
https://www.outsystems.com/forums/discussion/92735/transferring-data-between-database-foreign-languagejapanese-data-is-not-transfe/
https://stackoverflow.com/questions/761036/why-is-sql-server-storing-question-mark-characters-instead-of-japanese-character
https://dba.stackexchange.com/questions/90296/storing-japanese-characters-in-a-table
Thanks,
Sachin