RE: [OT off topic] Oracle Database Performace Issue

2006-02-12 Thread brettconnor
I haven't looked at the query in detail, too hard when it's not formatted. Things to check though: Without the schema (I missed the original email, appologies if the schema was included there) and indexes not much can be deduced. Most likely though there is a missing index or something is preventin

Re: i18n and the database...

2004-12-03 Thread brettconnor
I'd endorse this. UTF-8 or UTF-16 (depending on what languages you're expecting most of your data to be in) will handle anything. If you have Oracle it will also handle anything, it had NLS support before unicode, but your database must be set up with a suitable character set. It is completely a no

Re: OT Useful Validation Routines

2004-11-26 Thread brettconnor
This pattern will reject some valid email addresses. The local part (the bit bofore the @) is interpreted by the target email system and should not be interpreted by source or intermediate systems. The meaning of it, including what characters are legal, is entirely up to each email host. I cannot q