Issue #75 resolved
utf8 text and braces (',")
Originally reported on Google Code with ID 75
What steps will reproduce the problem? 1. i made a db in well-known firefox sqlite plugin. it contains text fields like: 'Рога и копыта' or even w/o braces: Уточняйте у менеджера . 2. But it seems not to be able to operate with strings like these in phpliteadmin. whenewer i try to change it, for example, to : 'Рога и копыта 2' it gives me an error i mentioned below. 3. the only way to manipulate with these strings is to rewrite it in "" braces. like: "Рога и копыта 2". but now i should reedit all my fields in DB to double braces ((. What is the expected output? What do you see instead? i see: Warning: SQLite3::query() [sqlite3.query]: Unable to prepare statement: 1, near "Рога": syntax error in <filepath> on line 669 i expected to see: automatically change ' to " if thereare any utf symbols, or teach phpliteadmin to work with ' braces with utf. What version of the product are you using? On what operating system? gentoo, define("VERSION", "1.9.0"); Please provide any additional information below. utf text w/o any braces is able to be filled into a field in firefox sqlite plugin too, but it need to be recontained in "" in phpliteadmin.
remort.net on 2011-12-13 19:28:31