Re: URL Encode via SQL?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Shaniqua Jones (kingOfPop_at_Neverland.com)
Date: 06/19/04 

Date: Sat, 19 Jun 2004 07:27:56 -0700

> SQL Server doesn't know what a URL is, and doesn't know which characters
> need to be encoded. You'd have to build your own function that steps
> through each character in the string and rebuilds it, or runs a many-level
> nested replace()).

    I don't know enough SQL to do that. Instead, I'm adding a new field to
the table called "URLEncodedID". Then, I'll write a little .NET app (C#)
that runs through an updates each record.

    It would be much easier if SQL Server had a way to call my C# method
directly from the SQL query. It seems like I read that such functionality
was going to be available in the next version of SQL Server. Is that true?
What's the timeline on that?

Relevant Pages

  • Re: Stored proc with version number ?
    ... in addition to letter characters from other languages. ... Certain symbols at the beginning of an identifier have special meaning ... in SQL Server. ... I choose> the existing stored proc uspTableSave and right click Properties. ...
    (microsoft.public.sqlserver.programming)
  • Re: Can you use osql in DTS?
    ... each one of these queries has in it the same first 18 characters (or ... it from Query #3. ... > Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... each one of these queries has in it the same first 18 characters (or ... it from Query #3. ... > Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.programming)
  • Re: sendStringParameterAsUnicode: How to insert unicode data corre
    ... We are using SAP XI and connecting it to SQL Server 2005 using JDBC. ... The destination columns are nvarchar and store unicode data correctly. ... is unable to display the characters you have. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: How to store HTML code in SQL server table
    ... but varchar cannot be properly used with unicode ... and has a maximum length of 8000 characters. ... > I support the Professional Association of SQL Server and it's> community of SQL Server professionals. ... >> I'm creating something like a web site builder in ASP.Net, and I need to>> store an HTML code in the SQL server table. ...
    (microsoft.public.sqlserver.server)