google map可以搜相邻区域么 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

google map可以搜相邻区域么

google map可以搜相邻区域么# Java - 爪哇娇娃

B*g2013-06-23 07:06

1 楼

what will be to_char(char/varchar2) return? char or varchar2?
http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/functions133a.htm#1003495
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions179.htm#i1006717
http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_functions_2113.htm
9i return database character set. what is database character set.?
10g return VARCHAR2.
11g return text? what is test, is it just char?
SELECT *
FROM tab1
WHERE col1 = 'abc'
'a

d*e2013-06-23 07:06

2 楼

列出已知city临近的city.

B*g2013-06-23 07:06

3 楼

based on my test. 9i and 10g
to_char return char
'abc' is char
please confirm

【在 B*****g 的大作中提到】

: what will be to_char(char/varchar2) return? char or varchar2?
: http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/functions133a.htm#1003495
: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions179.htm#i1006717
: http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_functions_2113.htm
: 9i return database character set. what is database character set.?
: 10g return VARCHAR2.
: 11g return text? what is test, is it just char?
: SELECT *
: FROM tab1
: WHERE col1 = 'abc'

b*y2013-06-23 07:06

4 楼

不清楚，这个跟google map api是否有相关功能有关吧，你可以查查他家的reference

c*d2013-06-23 07:06

5 楼

to_char返还varchar2还是char很重要吗?
varchar2还是char只是内部存储的方式不同

B*g2013-06-23 07:06

6 楼

如果没有人用char做column就没问题。
咱们哪儿bt很多，非要用char。
结果就是
Tab1(ID number, char_col char(10))
record(1, 'abc ')
select count(1)
from tab1
where id = 1
and char_col = 'abc '
return 1
用to_char也解决不了。

【在 c*****d 的大作中提到】

: to_char返还varchar2还是char很重要吗?
: varchar2还是char只是内部存储的方式不同