没有办法在数据库里面直接处理, 只有借助邹老大说的2000扩展存储过程,2005 的CLR. ------------------------------ http://www.w3pop.com/learn/view/doc/jsref_encodeURI/ Definition and Usage 定义与用法 The encodeURI() function encodes a string as a URI. encodeURI()方法用于将字符串转换成URISyntax 语法 encodeURI(URIstring) Parameter 参数 Description 注释 URIstring URI字符串 Required. The URI to be encoded 必选项。所要转换的字符串 --------------------------------------------------------------------------------Tips and Notes 注意 Note: The encodeURI() function encodes special characters, with the exception of: , / ? : @ & = + $ #. Use the encodeURIComponent() function to encode these characters. 注意:encodeURI()方法不能编译, / ? : @ & = + $ #,请使用encodeURIComponent()方法进行编译。Tip: Use the decodeURI() function to decode URIs encoded with encodeURI(). 提示:用decodeURI()方法来反编译用encodeURI()编译的URI --------------------------------------------------------------------------------Example 实例 In this example we use encodeURI() to encode URIs: 在下面的例子中,我们将演示用encodeURI()编译URI:<script type="text/javascript"> document.write(encodeURI("http://www.w3pop.com")+ "<br />") document.write(encodeURI("http://www.w3pop.com/My first/")) document.write(encodeURI(",/?:@&=+$#")) </script> The output of the code above will be: 输出结果为:http://www.w3pop.com http://www.w3pop.com/My%20first/ ,/?:@&=+$# --------------------------------------------------------------------------------Try-It-Yourself Demos 互动演练 encodeURI() How to use encodeURI() to encode different URIs. 如何用encodeURI()来编译不同的URI
2005 就写个 clr 存储过程
2000 就写个扩展存储过程
只有借助邹老大说的2000扩展存储过程,2005 的CLR.
------------------------------
http://www.w3pop.com/learn/view/doc/jsref_encodeURI/
Definition and Usage
定义与用法
The encodeURI() function encodes a string as a URI.
encodeURI()方法用于将字符串转换成URISyntax
语法
encodeURI(URIstring) Parameter
参数 Description
注释
URIstring
URI字符串 Required. The URI to be encoded
必选项。所要转换的字符串
--------------------------------------------------------------------------------Tips and Notes
注意
Note: The encodeURI() function encodes special characters, with the exception of:
, / ? : @ & = + $ #. Use the encodeURIComponent() function to encode these characters.
注意:encodeURI()方法不能编译, / ? : @ & = + $ #,请使用encodeURIComponent()方法进行编译。Tip: Use the decodeURI() function to decode URIs encoded with encodeURI().
提示:用decodeURI()方法来反编译用encodeURI()编译的URI
--------------------------------------------------------------------------------Example
实例
In this example we use encodeURI() to encode URIs:
在下面的例子中,我们将演示用encodeURI()编译URI:<script type="text/javascript">
document.write(encodeURI("http://www.w3pop.com")+ "<br />")
document.write(encodeURI("http://www.w3pop.com/My first/"))
document.write(encodeURI(",/?:@&=+$#"))
</script> The output of the code above will be:
输出结果为:http://www.w3pop.com
http://www.w3pop.com/My%20first/
,/?:@&=+$#
--------------------------------------------------------------------------------Try-It-Yourself Demos
互动演练
encodeURI()
How to use encodeURI() to encode different URIs.
如何用encodeURI()来编译不同的URI
能实现吗 ...
谁 给写个?
先谢过了..