CODEWITHSUNDEEP
phpzend-frameworksqlite
whisher
whisher

Reputation: 11

Zend Sqlite utf 8

sorry to bother you.

I'm wondering if using utf 8 in sqlite is the same of mysql therefore it's enough set this lines in application.ini 

resources.db.adapter = "PDO_SQLITE" 

resources.db.params.dbname = APPLICATION_PATH "/../data/db/guestbook.db" 

resources.db.params.charset = UTF8 

resources.db.isDefaultTableAdapter = true 


or I should do a query in my bootstrap like

PRAGMA encoding = "UTF-8";

BTW where does zf do the work (I mean in which class) ?

Bye.

Upvotes: 1

Views: 569

Answers (2)

Whisher
Whisher

Reputation: 32726

In The Definitive Guide to SQLite I found [Some settings such as page size and character encoding (UTF-8, UTF-16, etc.) cannot be changed once the database is created, so this interim is where you have a chance to specify them.]

So you should set the utf 8 encoding in the script where you create the DB.

Upvotes: 0

Gordon
Gordon

Reputation: 316989

I dont see anything in

that suggests a charset option will be applied if given.

Upvotes: 1

Related Questions