Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Location
    UK
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Foreign Characters!

    I have a form that allows a user to enter in some data. It then inserts the data into a table in an oracle database.

    The problem that I am having is when I pass in a foreign character such as a '' it converts it to a 't'.

    Has this happened to any one else - anyone know how to resolve this?

    Thanks

  • #2
    Regular Coder dniwebdesign's Avatar
    Join Date
    Dec 2003
    Location
    Carrot River, Saskatchewan
    Posts
    838
    Thanks
    15
    Thanked 9 Times in 9 Posts
    I don't know much about oracle or if this is right but you can check to see if the field in your database is set for varchar. This is variable character.
    Dawson Irvine
    CEO - DNI Web Design
    http://www.dniwebdesign.com

  • #3
    Regular Coder
    Join Date
    Jun 2002
    Location
    UK
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yeah - they are all set as Varchar's....

    Do you think this is an Oracle thing or PHP?

  • #4
    Regular Coder
    Join Date
    Jun 2002
    Location
    UK
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The database characterset is WE8ISO8859P1 and so is Apache....

    I can pass a '' from a form to a php page and it will display '' - however, when i pass '' into my stored procedure it inserts a 't' into the database....

    Could this be the OCI drivers i'm using to connect?

    Anyone else had this problem?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •