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 !
> 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

-------------------------------------------------------------------------
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

Reply via email to