Column value stored as lowercase in SQL-DB (v11)

This public forum is for user-to-user discussions of ASPMaker. Note that this is not support forum.

Column value stored as lowercase in SQL-DB (v11)

Postby emoffster » Wed Jan 10, 2018 10:29 pm

Hi,
I've got this ID field (varchar(20)), in a table, which always stores its value in SQL-DB as lowercase, although added as uppercase, from ASPMaker form (11). I can't find any setting, where I've mistakenly added this setting.
Anyone got a clue?

BR,
Emil
emoffster
 
Posts: 16
Joined: Mon Jan 21, 2013 5:14 pm

Re: Column value stored as lowercase in SQL-DB

Postby Webmaster » Thu Jan 11, 2018 9:38 am

1. In Row_Inserting / Row_Updating server event, write out the value to check whether the value is actually in lowercase. For example:

Response.Write "current value: " & <FieldName>.CurrentValue & "<br>"
Response.Write "db value: " & <FieldName>.DbValue & "<br>"
Response.Write "value: " & rsnew("<FieldName>") & "<br>"

2. Use database engine tools to check whether the actual value stored in the database are actually in lowercase
Webmaster
 
Posts: 10734
Joined: Fri Aug 06, 2004 5:59 pm

Re: Column value stored as lowercase in SQL-DB

Postby emoffster » Thu Jan 11, 2018 2:08 pm

It is actually stored as lowercase in the database, although its written (inputted) in uppercase.
emoffster
 
Posts: 16
Joined: Mon Jan 21, 2013 5:14 pm

Re: Column value stored as lowercase in SQL-DB (v11)

Postby Webmaster » Thu Jan 11, 2018 6:26 pm

As explained:

> In Row_Inserting / Row_Updating server event, write out the value to check whether the value is actually in lowercase. For example:

Response.Write "current value: " & <FieldName>.CurrentValue & "<br>"
Response.Write "db value: " & <FieldName>.DbValue & "<br>"
Response.Write "value: " & rsnew("<FieldName>") & "<br>"
Webmaster
 
Posts: 10734
Joined: Fri Aug 06, 2004 5:59 pm

Re: Column value stored as lowercase in SQL-DB (v11)

Postby emoffster » Fri Jan 12, 2018 5:27 pm

Ended up creating a trigger instead, which converts to Ucase.
emoffster
 
Posts: 16
Joined: Mon Jan 21, 2013 5:14 pm


Return to General Discussion (ASPMaker)