You searched for the word(s): userid:719741

More Search Options

RSS Available

• Re: utf-8 in database varchar

  How do you use COLLATE? I thought the collate only affected sort order or comparisons? Does it also affect how the data is stored? If it does I assume it only affects which codepage is used to convert characters. This is not the same as UTF-8 encoding. I don't think there is a collation to force storage in utf-8 format.

  Posted to Localization (Forum) by skysailor on 5/23/2007

• Re: utf-8 in database varchar

  Is it possible for a function to return a varchar with different lengths? It seems as though I need to decalre the return variable as say type varchar(100). I need to be able to handle various string lengths. Can I pass in the length of the string and use that when defining the varchar inoput and output lengths? Otherwise I need a function for every possible string field length.

  Posted to Localization (Forum) by skysailor on 5/23/2007

• Re: utf-8 in database varchar

  I don't use stored procedures in the existing application. And there are two many tables to create stored procedures for them all. The code would have to change too much. So for now I am stuck with varchar fields. Is it not possible to cast the nvarchar to a varchar when saving the data to the database? I tried to write a stored function and it gives and exception. My function was :- CREATE FUNCTION dbo.fnStringWrite ( @S nvarchar(100) ) RETURNS varchar(100) AS BEGIN DECLARE @RETURN varchar(100

  Posted to Localization (Forum) by skysailor on 5/23/2007

• Re: Custom DB field handlers

  Thankyou, the functions were very helpful. I changed the internal type to BIT instead of CHAR(1) and it worked really well. In VS2005 Datasets these fields now appear as Boolean.

  Posted to Data Access and ObjectDataSource Control (Forum) by skysailor on 5/23/2007

• Re: utf-8 in database varchar

  So can the stored procedure return a field as a different datatype to the one stored? How is this conversion handled? Can you ensure that the varchar is encoded as utf-8 and not using a codepage?

  Posted to Localization (Forum) by skysailor on 5/21/2007

• Re: Custom DB field handlers

  Thankyou. That is very helpful. Adding a stored procedure layer for compatability is probably a good idea. I have not used stored procedures before. I was wondering if you could give a function/proc for UPDATE/INSERT. When storing I need to convert back from a Boolean to the T/F string. But if the field if nullable then the F should be stored as a NULL. Thanks again.

  Posted to Data Access and ObjectDataSource Control (Forum) by skysailor on 5/21/2007

• Re: Custom DB field handlers

  We don't use any stored procedures. It uses direct table access. We have many fields over many tables with this boolean treatment. We would also need to be able to read and write the field as Boolean.

  Posted to Data Access and ObjectDataSource Control (Forum) by skysailor on 5/20/2007

• Custom DB field handlers

  Is it possible to create custom database fields handlers for use with datasets/datatables in VS2005? I would like to do some dataconversions when reading some fields from the database. For example we have some fields that have F/T as character text and I'd like to convert that to a Boolean type internally. Is this possible?

  Posted to Data Access and ObjectDataSource Control (Forum) by skysailor on 5/18/2007

• utf-8 in database varchar

  We have existing SQL Server databases with all text fields defined as varchar (not nvarchar) and the text in them is actually UTF-8. Our old system (written in Delphi) will read and write those strings correctly and display the international characters on a web page etc. We are rewriting our system in ASP.NET and using Datasets to access the data. Reading/writing the data does not treat the data as utf-8. How can I get it to treat it as utf-8?

  Posted to Localization (Forum) by skysailor on 5/18/2007

• Re: Calling Static methods on Code Behind class of WebForm

  I found that if I put a <%@ Reference Page="rrrr.aspx" %> driective in one page then I can refer to the other page class file directly from the first page using the ASP namespace. That is exactly what I wanted. However it can't be used from app_code classes. And the killer - it can't be used if you Publish your web site!! So close. I have to publish/compile my web site.

  Posted to Web Forms (Forum) by skysailor on 4/19/2007