Commitc5ba660

committed

Doc: explain that the string types can't store \0 (ASCII NUL).

This restriction was mentioned in connection with string literals,but it wasn't made clear that it's a general restriction not justa syntactic limitation in query strings.Per unsigned documentation comment.Discussion:https://postgr.es/m/160720552914.710.16625261471128631268@wrigleys.postgresql.org

1 parentdfd8bf2 commitc5ba660Copy full SHA for c5ba660

File tree

-4

lines changed

-4

lines changed

Lines changed: 9 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1166,6 +1166,14 @@ SELECT '52093.89'::money::numeric::float8;`
`1166`	`1166`	`regular expressions.`
`1167`	`1167`	`</para>`
`1168`	`1168`
	`1169`	`+ <para>`
	`1170`	`+ The characters that can be stored in any of these data types are`
	`1171`	`+ determined by the database character set, which is selected when`
	`1172`	`+ the database is created. Regardless of the specific character set,`
	`1173`	`+ the character with code zero (sometimes called NUL) cannot be stored.`
	`1174`	`+ For more information refer to <xref linkend="multibyte"/>.`
	`1175`	`+ </para>`
	`1176`	`+`
`1169`	`1177`	`<para>`
`1170`	`1178`	`The storage requirement for a short string (up to 126 bytes) is 1 byte`
`1171`	`1179`	`plus the actual string, which includes the space padding in the case of`
`@@ -1203,10 +1211,7 @@ SELECT '52093.89'::money::numeric::float8;`
`1203`	`1211`	`<para>`
`1204`	`1212`	`Refer to <xref linkend="sql-syntax-strings"/> for information about`
`1205`	`1213`	`the syntax of string literals, and to <xref linkend="functions"/>`
`1206`		`- for information about available operators and functions. The`
`1207`		`- database character set determines the character set used to store`
`1208`		`- textual values; for more information on character set support,`
`1209`		`- refer to <xref linkend="multibyte"/>.`
	`1214`	`+ for information about available operators and functions.`
`1210`	`1215`	`</para>`
`1211`	`1216`
`1212`	`1217`	`<example>`

Comments

(0)