Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

runrig (3385)

runrig
  dougwNO@SPAMcpan.org

Just another perl hacker somewhere near Disneyland

I have this homenode [perlmonks.org] of little consequence on Perl Monks [perlmonks.org] that you probably have no interest in whatsoever.

I also have some modules [cpan.org] on CPAN [cpan.org] some of which are marginally [cpan.org] more [cpan.org] useful [cpan.org] than others.

Journal of runrig (3385)

Thursday March 08, 2007
09:05 PM

Sybase annoyances/quirks

[ #32621 ]
New job, new database, new annoyances to get over. Same ol' same ol'.
  • Default datetime format not ISO format.
  • Datetime to char conversion function doesn't have ISO as a choice (but lots of others)
  • Table and column names are case sensitive ("select foo" ne "select FOO").
  • ODBC driver prepares statements, but barfs after executing a few times.

Updating the ODBC driver might fix the problem (Data type for parameter x has changed since first SQLExecute call), but it's a commercial driver, I don't have admin rights on my pc, and I'd have to get the planets aligned first.

And, writing an "iso_format(datetime)" stored procedure might be a good idea, but there's plenty of code already that depends on the current date format.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • The case sensitivity on table names is actually dependent on how the charachter set of the dataserver is configured (i.e. whether comparisons with data in tables is case sensitive or not). That configuration applies to the repository tables (which store the user table names) as well.