Timezones / Collation
Posted: Sat Oct 14, 2006 2:13 am
Hi All,
Does anyone have any suggestions or good web sources on setting timezones and the correct uses of Colloation?
I'm currently using "latin1_swedish_ci" as it was the default when creating the database. But am having weird date issues since upgrading to MySQL5/PHP5.
Can anyone suggest the 'best' collation/charset for a fairly basic web interface used for invoicing/statements in a closed intranet environment?
Or is like asking what car should I drive?
I've been prompted to looking down this patch as i've turned 'strict' error reporting on and am getting the following error :
Does anyone have any suggestions or good web sources on setting timezones and the correct uses of Colloation?
I'm currently using "latin1_swedish_ci" as it was the default when creating the database. But am having weird date issues since upgrading to MySQL5/PHP5.
Can anyone suggest the 'best' collation/charset for a fairly basic web interface used for invoicing/statements in a closed intranet environment?
Or is like asking what car should I drive?
I've been prompted to looking down this patch as i've turned 'strict' error reporting on and am getting the following error :
tia, Will./[/quote]PHP Strict Standards: date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Jayapura' for 'CST/9.0/no DST' instead in /var/www/html/db/statements.php on line 47