problem saving non english strings to the db via an INSERT INTO module upload script - Language Packs [Lead: Vicenç Masanas]

Forum DotNetNuke® Pro... Language Packs ... problem saving non english strings to the db via an INSERT INTO module upload script

2/8/2006 3:00 AM

	eyal mayroz
10 posts

problem saving non english strings to the db via an INSERT INTO module upload script

Hi,

I am trying to upload 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.

Any ideas?

thanks

2/8/2006 5:23 PM

	eyal mayroz
10 posts

Re: problem saving non english strings to the db via an INSERT INTO module upload script

Just more info on the problem: 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??

Page 1 of 1

Forum

DotNetNuke® Pro...

Language Packs ...

problem saving non english strings to the db via an INSERT INTO module upload script