Thank. I am very late to see your comment. I used URI-encoding function in
Lua page.
-- url decoder
function urldecode(str)
str = string.gsub(str, '+', ' ')
str = string.gsub(str, '%%(%x%x)', function(h) return
string.char(tonumber(h, 16)) end)
str = string.gsub(str, '\r\n', '\n')
return str
end
-- url encoder
function urlencode(str)
if str then
str = string.gsub(str, '\n', '\r\n')
str = string.gsub(str, '([^%w ])', function(c) return
string.format('%%%02X', string.byte(c)) end)
str = string.gsub(str, ' ', '+')
end
return str
end
On Monday, September 2, 2013 7:41:40 PM UTC+9, Sergey Lyubka wrote:
>
> I've tried your example with test/page.lp, inserting '한글' by hands, and
> also
> other UTF-8 characters, e.g. Cyrillic and Hebrew. Works fine for me,
> browser renders
> those strings as expected.
> Try do this in your lua snippet:
> db:exec('PRAGMA encoding="UTF-8"; ')
>
>
>
> On Sat, Aug 24, 2013 at 2:00 AM, 오치민 <[email protected] <javascript:>>wrote:
>
>> From .lp Lua page it is not possible to show characters in unicode.
>> I added unicode characters using sqlite3 console application.
>>
>> <database value input - manually>
>> sqlite> insert into test ('1', '한글');
>>
>> when I try to show this row the characters are broken n Lua server page not
>> in console application where i can see unicode properly.
>>
>> <.lp code for reading row from sqlite3>
>>
>> stmt = db:prepare('SELECT * FROM test;')
>> while stmt:step() == sqlite3.ROW do
>> local v = stmt:get_values()
>> mg.write(v[1] .. ' ' .. v[2] .. ' ' .. v[3] .. ' '.. v[4] .. ' ' ..
>> v[5] .. ' ' .. v[6] .. ' ' .. v[7] ..'<br>')
>> end
>>
>> <result in browser>
>> 1234 �ѱ���
>>
>>
>> In other case when I save unicode characters using Lua server script
>>
>> it is not properly saved in sqlite3 database.
>>
>> They are broken like 1234 �ѱ���
>>
>> when i check in sqlite3 console application
>>
>>
>> I think sqlite3 in lua server page is not able to transfer unicode
>> characters properly.
>>
>> (I am a newbie here)
>>
>>
>> Now I think to use uri-encode to avoid this problem for saving and reading
>> unicode characters.
>>
>> But every time i need to encode them with JavaScript and it is difficult to
>> split encoded characters from query-string of http-request.
>>
>>
>> * Actually I wrote first here -
>> https://code.google.com/p/mongoose/issues/detail?id=402&can=6&q=unicode
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "mongoose-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> Visit this group at http://groups.google.com/group/mongoose-users.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
--
You received this message because you are subscribed to the Google Groups
"mongoose-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/mongoose-users.
For more options, visit https://groups.google.com/groups/opt_out.
