On Sunday 15 October 2006 11:28 am, Jeff Vian wrote: > On Fri, 2006-10-13 at 16:06 -0500, R Pennington wrote: > > Is there any restrictions on which characters can be used in alpha > > numeric fields like the part description ? I seem to remember some > > problems in the past with certain characters. Does the manual mention it > > anywhere ? > > Are / and " ok ? > > I think you need to check which characters are valid per the SQL > definition standards. IIRC the two you list are explicitly prohibited > since the first is a mathematical operator (division) and the " is a > delimiter for text fields. You can use any characters in a text field > that are allowed by the SQL language definition. > > The documentation at http://www.postgresql.org/docs/8.1/static/sql.html > or http://www.postgresql.org/docs/8.1/static/index.html may be a good > starting point.
Thanks Jeff ! That makes perfect sense for entries directly into the database tables, but in this case i was concerned about what is valid in the sql-ledger application. I would assume that the the sql-ledger code would try escape all the problem characters, but I seem to remember a thread at one time that mentioned that some characters are not usable even in the sql-ledger application itself. I can't find anything in the archives though. In the next few months I'm going to have to import a whole new catalog of parts and.. unlike last time... i'm going to import them via the SQL-ledger api. I guess i'll just stuff a string of all the possible characters into the add part form and see if it works. :) Have a good day ! Roy ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sql-ledger-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
