Last post Feb 27, 2006 11:19 AM by hooligannes97
Feb 18, 2006 03:28 AM|lilon|LINK
Hi, this is from the localization forums where I had no luck:
I am trying to insert some rows which contain some non english scripts (Hebrew) to the dnn_Lists (Core) table using INSERT INTO statements within my 01.00.00.SqlDataProvider file. I've scripted my development site's Lists table and pasted the results into
my above mentioned file. I've saved the file as utf-8 with signature and the Hebrew strings are saved there properly. However when I use the upload dnn engine to upload the module and the script, although I get no error, the rows are inserted into the lists
table properly, but the Hebrew values are stored as ???? ???? ? ??
It is not an issue of data type since the Lists table uses nvarchar, which is good to save Hebrew. Also, if I use the DNN UI to create lists values in Hebrew and store them in the table it works well.
I tried and succeeded in pasting and running the ISERT INTO statements as script through the SQL interface of DNN. This time the Hebrew strings are saved properly into the database. Why would it be different if run through the upload engine??
Feb 18, 2006 09:07 AM|hooligannes97|LINK
Feb 19, 2006 03:19 AM|lilon|LINK
thanks for your answer.
I did however saved it as unicode (utf-8 with signature is the proper way to save such unicode chars)
Feb 27, 2006 03:12 AM|lilon|LINK
Feb 27, 2006 11:19 AM|hooligannes97|LINK