Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL values won't keep case

Posted on 2005-04-05
2
Medium Priority
?
186 Views
Last Modified: 2013-12-25
How come when I retrive values from an sql database in perl, everything is in lowercase. I looked at the actual database and everything is capitalized right.

Here's an example problem:

KeepCool - keepcool

Why is it doing this?

I'm not doing anything to the value when I retrieve it in the perl script.

Thanks,
-Stephen
0
Comment
Question by:stjowa
2 Comments
 
LVL 18

Accepted Solution

by:
kandura earned 2000 total points
ID: 13712998
can you show us some code? specifically the part where you get the values from the database. it's definitely not normal behaviour; I run a lot of projects with databases, and never have this issue.
0
 

Author Comment

by:stjowa
ID: 13713897
I'm sorry I figured out what I was doing... heh it wasn't anything to do with the database, but rather a cookie user name getting stored instead of the "true" member name... resulting in all lower case.

Thanks for the attempted help
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hope you'll find this tutorial useful and interesting. So let's try to extend Tcl with a new package.  For anyone more deeply interested please check out the book "Practical Programming in Tcl and Tk". It's really one of the best written books abo‚Ķ
Measuring Server's processing rate with a simple powershell command. The differences in processing rate also was recorded in different use-cases, when a server in free and busy states.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Suggested Courses

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question