I have an asp page that updates a ms sql 2k db.
If put a name in a db field of 12 characters should the nvarchar length be
set to 24 to allow for double byte characters.
Should I be using nvarchar or char as when i make my input field length in
asp page 12 the insert fails but if i make it 3 or 4 it works ok even though
the db field length is set to same as asp field length.
How do I convert an nvarchar field to smalldatetime format?
My nvarcharfield (saledatetext) is in the format YYYY-MM-DD.
I want to convert is to smalldatetime (field: saledate)
I have a ms sql table called data. Two fields, saledate(smalldatetime),saledatetext(nvarchar). I have dates (ex. 05/04/05) in the saledatetext, but I need this converted into smalldatetime format and placed in the saledate column. Can you tell me how to do this using sql query analyzer?
View Replies View RelatedI have an nvarchar field . These have entries like 2,3,2.5, etc. It's the decimals that get me. I want to be able to search for all listings with at least x bathrooms.
If I select all with at least 2 bathrooms, how can I get the ones with 2.5 to show. Is this possible or do I need to reconfigure the field type?
i have a simple table with a field called "authors". this filed have a nvarchar(max) type (in MSSql 2005). i have a simple query "Select authors FROM table". in query analizer this return the value of authors, but when i run this in asp page, the field is empty.
in the code i have:
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, Conn, 1, 1
but rs("Authors") is empty.
If i change the type (and i use nvarchar(4000) for authors) there is no problem. for the connection i have Driver={SQL Native Client}.