[Solar-talk] UTF-8

[Paul M Jones]

On Jul 17, 2006, at 10:26 AM, Rodrigo Moraes wrote:

> I think the charset for the database tables should also be UTF-8
> encoded (and thus Solar_Sql_Table method for table creation should be
> changed).

Do you know how to do that for the four databases Solar currently  
supports?  MySQL probably not hard, but it needs to cover Sqlite,  
Postgres, and MS-SQL too.


> I'm not very used to I18n issues, but if this is really a
> requirement, well, it should be done so Solar_Apps will be ready for
> I18n.

I agree.


>> Embedded in the various model objects that compose Solar_Content:
>> look in Solar_Model_Nodes in the _setup() method, where $col and $idx
>> are defined.  The table is automatically created the first time the
>> Solar_Model_Nodes object is instantiated.
>
> Hmmm, thanks. I had this newbie doubt after I've tried to insert a
> bookmark and got a exception "Unknown column 'areas.title' in 'field
> list'.". Forget it, the tables were created automatically and
> something happened, but I'll drop them, start again and see what I've
> done wrong.

Let us know how that goes (probably better as a separate thread though).



--

Paul M. Jones  <http://paul-m-jones.com>

Solar: Simple Object Library and Application Repository
for PHP5.   <http://solarphp.com>

Savant: The simple, elegant, and powerful solution for
templates in PHP.   <http://phpsavant.com>